﻿CREATE TABLE [dbo].[ProgramType] (

	[Id] [dbo].[Id] NOT NULL  IDENTITY(1000000000, 1), 

    [Name] [dbo].[Name] NOT NULL, 

    [Description] [dbo].[Description] NOT NULL, 
    
	[Code] [dbo].[BusinessCode3] NOT NULL,
	
	[Enabled] [dbo].[Enabled] NOT NULL DEFAULT 1,

    [CreateId] [dbo].[Name] NOT NULL DEFAULT SUSER_NAME () , 

    [CreateDateTime] [dbo].[CreateModifiedDateTime] NOT NULL DEFAULT GETDATE() , 

    [ModifiedId] [dbo].[Name] NOT NULL DEFAULT SUSER_NAME (),

    [ModifiedDateTime] [dbo].[CreateModifiedDateTime] NOT NULL DEFAULT GETDATE(), 
 
    CONSTRAINT [PK_ProgramType] PRIMARY KEY ([Id]), 

	CONSTRAINT [UNQ_ProgramType_Name] UNIQUE (Name),

    CONSTRAINT [UNQ_ProgramType_Code] UNIQUE (Code)

)
